How do you do subqueries

join shbcf.ru